﻿
using System.Data;
using System.Text;
using Microsoft.ApplicationBlocks.Data;

namespace DataObject.Photo
{
    internal class PhotoDAL : DAL
    {
        internal static IDataReader CMS_Photos_GetByMemberID(int id, int round)
        {
            sb = new StringBuilder();
            sb.AppendFormat("SELECT * FROM [{0}] ", Constants.Table_Photos.TableName);
            sb.AppendFormat("WHERE [{0}] = {1} ", Constants.Table_Photos.Member_ID, id);
            sb.AppendFormat("AND [{0}] = {1} ", Constants.Table_Photos.Photo_Round, round);
            return SqlHelper.ExecuteReader(Conn, CommandType.Text, sb.ToString());
        }
    }
}
